
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create view [dbo].[tab_categoria] as
SELECT	distinct idCategoriaSARH as tab_categoria_id, --idCargo as tab_categoria_id,
		cargo as tab_categoria_desc,
		case cobraxHora when 'S' then 2 else 1 end as tab_categoria_cobra_hora
FROM tb_cargosSalariales as c 
GO
